package com.itwill.ecom.orders;

import java.sql.Date;

import org.codehaus.jackson.annotate.JsonProperty;
import org.codehaus.jackson.map.annotate.JsonRootName;

/*
 CREATE TABLE ORDERS
 (
 ORDERS_NO NUMBER(10) NOT NULL PRIMARY KEY,
 ORDERS_MEMBER NUMBER(10) NOT NULL,
 ORDERS_DATE DATE DEFAULT SYSDATE NOT NULL,
 ORDERS_PHONE VARCHAR2(20) NOT NULL,
 ORDERS_ZIP VARCHAR2(20) NOT NULL,
 ORDERS_ADDR1 VARCHAR2(50) NOT NULL,
 ORDERS_ADDR2 VARCHAR2(50) NOT NULL,
 ORDERS_MSG VARCHAR2(100),
 CONSTRAINT ORDERS_FK_MEMBER FOREIGN KEY (ORDERS_MEMBER)
 REFERENCES MEMBER(MEMBER_NO) ON DELETE SET NULL
 );
 */
@JsonRootName("OrdersBeans")
public class OrdersBeans {
	@JsonProperty("orders_no")
	private int orders_no; // 주문번호
	@JsonProperty("orders_member")
	private int orders_member; // 주문자 회원 번호
	@JsonProperty("orders_date")
	private Date orders_date; // 주문일
	@JsonProperty("orders_name")
	private String orders_name; // 수취인 이름
	@JsonProperty("orders_email")
	private String orders_email; // 수취인 email
	@JsonProperty("orders_phone")
	private String orders_phone; // 수취인 전화번호
	@JsonProperty("orders_zip")
	private String orders_zip; // 수취인 우편번호
	@JsonProperty("orders_addr1")
	private String orders_addr1; // 수취인 기본 주소
	@JsonProperty("orders_addr2")
	private String orders_addr2; // 수취인 상세 주소
	@JsonProperty("orders_price")
	private String orders_price; // 물품 총 금액
	@JsonProperty("orders_payments")
	private String orders_payments; // 결제 수단
	@JsonProperty("orders_msg")
	private String orders_msg; // 결제시 남길 메시지

	public OrdersBeans() {
	}

	public OrdersBeans(int orders_no, int orders_member, Date orders_date,
			String orders_name, String orders_email, String orders_phone,
			String orders_zip, String orders_addr1, String orders_addr2,
			String orders_price, String orders_payments, String orders_msg) {
		super();
		this.orders_no = orders_no;
		this.orders_member = orders_member;
		this.orders_date = orders_date;
		this.orders_name = orders_name;
		this.orders_email = orders_email;
		this.orders_phone = orders_phone;
		this.orders_zip = orders_zip;
		this.orders_addr1 = orders_addr1;
		this.orders_addr2 = orders_addr2;
		this.orders_price = orders_price;
		this.orders_payments = orders_payments;
		this.orders_msg = orders_msg;
	}

	public int getOrders_no() {
		return orders_no;
	}

	public void setOrders_no(int orders_no) {
		this.orders_no = orders_no;
	}

	public int getOrders_member() {
		return orders_member;
	}

	public void setOrders_member(int orders_member) {
		this.orders_member = orders_member;
	}

	public Date getOrders_date() {
		return orders_date;
	}

	public void setOrders_date(Date orders_date) {
		this.orders_date = orders_date;
	}

	public String getOrders_name() {
		return orders_name;
	}

	public void setOrders_name(String orders_name) {
		this.orders_name = orders_name;
	}

	public String getOrders_email() {
		return orders_email;
	}

	public void setOrders_email(String orders_email) {
		this.orders_email = orders_email;
	}

	public String getOrders_phone() {
		return orders_phone;
	}

	public void setOrders_phone(String orders_phone) {
		this.orders_phone = orders_phone;
	}

	public String getOrders_zip() {
		return orders_zip;
	}

	public void setOrders_zip(String orders_zip) {
		this.orders_zip = orders_zip;
	}

	public String getOrders_addr1() {
		return orders_addr1;
	}

	public void setOrders_addr1(String orders_addr1) {
		this.orders_addr1 = orders_addr1;
	}

	public String getOrders_addr2() {
		return orders_addr2;
	}

	public void setOrders_addr2(String orders_addr2) {
		this.orders_addr2 = orders_addr2;
	}

	public String getOrders_price() {
		return orders_price;
	}

	public void setOrders_price(String orders_price) {
		this.orders_price = orders_price;
	}

	public String getOrders_payments() {
		return orders_payments;
	}

	public void setOrders_payments(String orders_payments) {
		this.orders_payments = orders_payments;
	}

	public String getOrders_msg() {
		return orders_msg;
	}

	public void setOrders_msg(String orders_msg) {
		this.orders_msg = orders_msg;
	}
}
